﻿CREATE PROCEDURE [Sample].[GetDealersForCustomer]
	@customerID int,
	@phoneMask nvarchar(50) = '%'
AS
	SELECT * 
	from Sample.Dealers D
	where  D.CustomerID = @customerID
	  --and  D.PhoneNumber like @phoneMask
